declare @idoc int
declare @doc varchar(1000)
set @doc ='
<ROOT>
<Customer CustomerID="VIN\r\nET" ContactName="Paul Henriot">
   <Order OrderID="10248" CustomerID="VI\r\nNET" EmployeeID="5" 
           OrderDate="1996-07-04T00:00:00">
      <OrderDetail ProductID="11" Quantity="12"/>
      <OrderDetail ProductID="42" Quantity="10"/>
   </Order>
</Customer>
<Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
   <Order OrderID="10283" CustomerID="LILAS" EmployeeID="3" 
           OrderDate="1996-08-16T00:00:00">
      <OrderDetail ProductID="72" Quantity="3"/>
   </Order>
</Customer>
</ROOT>'
--Create an internal representation of the XML document.
exec sp_xml_preparedocument @idoc OUTPUT, @doc
-- SELECT stmt using OPENXML rowset provider
Declare @sum nvarchar(128);
set @sum = (SELECT Top 1 REPLACE(REPLACE(CustomerID,CHAR(10),CHAR(13)+CHAR(10)) as abc
FROM   OPENXML (@idoc, '/ROOT/Customer/Order/OrderDetail',2)
         WITH (OrderID       int         '../@OrderID',
               CustomerID  varchar(10) '../@CustomerID',
               OrderDate   datetime    '../@OrderDate',
               ProdID      int         '@ProductID',
               Qty         int         '@Quantity'))
print @sum

---------------------------------------------------------------------------------------
-- XML to Stored Procedure, all \r\n or \n will be translated to \n which is CHAR(10)
-- so the solution to keep \r\n is to replace CHAR(10) with CHAR(13)+CHAR(10)
---------------------------------------------------------------------------------------